<%
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select * from (select top 10 * from Advertisement order by ID desc) order by Hot desc"
rs.Open strSQL, dbconnection, adOpenDynamic, 3
strPics = ""
strLinks = ""
strTexts = ""

do while not rs.eof
	strPics = strPics & rs("Pic") & "|"
	strLinks = strLinks & rs("Url") & "|"
	strTexts = strTexts & rs("Text") & "|"	
	rs.movenext
loop
set rs = nothing
l = len(strPics)
strPics = Left(strPics, l - 1) 
l = len(strLinks)
strLinks = Left(strLinks, l - 1) 
l = len(strTexts)
strTexts = Left(strTexts, l - 1) 
%>

<table width="478" height="240" border="0" cellpadding="0" cellspacing="0" background="images/ab.gif">
  <tr>
    <td><a target=_self href="javascript:goUrl(aaa)"> <span class="f14b">
<script type="text/javascript">

 var focus_width=460
 var focus_height=200
 var text_height=18
 var swf_height = focus_height+text_height
 
 var pics="<%=strPics%>"
 var links="<%=strLinks%>"
 var texts="<%=strTexts%>"
 
 document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
 document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="focus.swf"><param name="quality" value="high"><param name="bgcolor" value="#F0F0F0">');
 document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
 document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
 document.write('<embed src="pixviewer.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#F0F0F0" quality="high" width="'+ focus_width +'" height="'+ focus_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />');  document.write('</object>');
 

 </script>
</span></a></td>
  </tr>
</table>
